<!DOCTYPE html>
<html lang=zh-CN>
<head>
<meta charset=utf-8>
<title>数据库实验五 实验七 SQL命令 | Cweili Beta</title>
<meta name=viewport content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no">
<meta name=description content="数据库实验五 和 实验七 的 SQL 命令记录">
<meta property=og:type content=article>
<meta property=og:title content="数据库实验五 实验七 SQL命令">
<meta property=og:url content="http://cweili.gitcafe.com/database-experiment-5-7/">
<meta property=og:site_name content="Cweili Beta">
<meta property=og:description content="数据库实验五 和 实验七 的 SQL 命令记录">
<meta name=twitter:card content=summary>
<meta name=twitter:title content="数据库实验五 实验七 SQL命令">
<meta name=twitter:description content="数据库实验五 和 实验七 的 SQL 命令记录">
<link rel=alternative href=/atom.xml title="Cweili Beta" type=application/atom+xml>
<link rel=icon href=favicon.png>
<link rel=stylesheet href=//libs.baidu.com/bootstrap/3.2.0/css/bootstrap.min.css type=text/css>
<link rel=stylesheet href=../css/style.css type=text/css>
<!--[if lt IE 9]><script src="//cdn.staticfile.org/html5shiv/3.7/html5shiv.min.js" type="text/javascript"></script><![endif]-->
</head>
<body>
<div id=container>
<nav id=mobile-nav class=visible-xs>
<a href="/" class=mobile-nav-link>首页</a>
<ul class=category-list><li class=category-list-item><a class=category-list-link href=../category/学习笔记>学习笔记</a><span class=category-list-count>40</span></li><li class=category-list-item><a class=category-list-link href=../category/小生活>小生活</a><span class=category-list-count>27</span></li><li class=category-list-item><a class=category-list-link href=../category/杂物>杂物</a><span class=category-list-count>9</span></li></ul>
<a href="/tag/%E7%9B%B8%E5%86%8C/" class=mobile-nav-link>相册</a>
<a href="/about/" class=mobile-nav-link>关于</a>
<div class=clearfix></div>
</nav>
<div id=wrap>
<!--[if lt IE 9]><p class="browsehappy alert alert-danger">您正在使用一个<strong>过时</strong>的浏览器。请<a href="http://browsehappy.com/" target="_blank">更新您的浏览器</a>来达到更好的体验。</p><![endif]-->
<header id=header>
<div id=banner></div>
<div id=header-outer class=outer>
<div id=header-inner class=inner>
<nav class=main-nav>
<div id=main-nav-toggle class="nav-icon visible-xs"><i class="fa fa-bars"></i></div>
<a class="main-nav-link hidden-xs" href="/">首页</a>
</nav>
<nav id=category-nav class=hidden-xs>
<ul class=category-list><li class=category-list-item><a class=category-list-link href=../category/学习笔记>学习笔记</a><span class=category-list-count>40</span></li><li class=category-list-item><a class=category-list-link href=../category/小生活>小生活</a><span class=category-list-count>27</span></li><li class=category-list-item><a class=category-list-link href=../category/杂物>杂物</a><span class=category-list-count>9</span></li></ul>
</nav>
<nav class="main-nav hidden-xs">
<a class=main-nav-link href="/tag/%E7%9B%B8%E5%86%8C/">相册</a>
<a class=main-nav-link href="/about/">关于</a>
</nav>
<nav id=sub-nav>
<a id=nav-rss-link class="nav-icon pull-right hidden-xs" href=/atom.xml title="RSS 订阅"><i class="fa fa-rss"></i></a>
<div id=nav-search-btn class="nav-icon pull-right" title=搜索><i class="fa fa-search"></i></div>
</nav>
<div id=search-form-wrap>
<form action=http://www.baidu.com/baidu accept-charset=utf-8 class=search-form target=_blank>
<input type=search name=word class=search-form-input placeholder=搜索>
<input id=search-form-submit type=submit value=&nbsp; class=search-form-submit>
<input name=tn type=hidden value=bds>
<input name=cl type=hidden value=3>
<input name=ct type=hidden value=2097152>
<input type=hidden name=si value=cweili.gitcafe.com>
<label class=search-form-submit for=search-form-submit><i class="fa fa-search"></i></label>
</form>
</div>
</div>
<div id=header-title class=inner>
<h1 id=logo-wrap>
<a href="/" id=logo>Cweili Beta</a>
</h1>
<h2 id=subtitle-wrap>
<a href="/" id=subtitle>I&#39;m working on it</a>
</h2>
</div>
</div>
</header>
<div class=outer>
<section id=main class=col-sm-9><article id=post-database-experiment-5-7 class="article article-type-post" itemscope itemprop=blogPost>
<div class=article-meta>
<a href="/database-experiment-5-7/" class=article-date>
<time datetime=2011-10-31T15:08:11.000Z itemprop=datePublished>2011-10-31</time>
</a>
<div class=article-category>
<a class=article-category-link href=../category/学习笔记>学习笔记</a>
</div>
</div>
<div class="article-inner jiathis_streak">
<header class=article-header>
<h2 class=article-title itemprop=name>
数据库实验五 实验七 SQL命令
</h2>
</header>
<div class=article-entry itemprop=articleBody>
<p> 数据库实验五 和 实验七 的 SQL 命令记录 <br><a id=more></a></p>
<figure class="highlight sql"><table><tr><td class=gutter><pre><div class=line>1</div><div class=line>2</div><div class=line>3</div><div class=line>4</div><div class=line>5</div><div class=line>6</div><div class=line>7</div><div class=line>8</div><div class=line>9</div><div class=line>10</div><div class=line>11</div><div class=line>12</div><div class=line>13</div><div class=line>14</div><div class=line>15</div><div class=line>16</div><div class=line>17</div><div class=line>18</div><div class=line>19</div><div class=line>20</div><div class=line>21</div><div class=line>22</div><div class=line>23</div><div class=line>24</div><div class=line>25</div><div class=line>26</div><div class=line>27</div><div class=line>28</div><div class=line>29</div><div class=line>30</div><div class=line>31</div><div class=line>32</div><div class=line>33</div><div class=line>34</div><div class=line>35</div><div class=line>36</div><div class=line>37</div><div class=line>38</div><div class=line>39</div><div class=line>40</div><div class=line>41</div><div class=line>42</div><div class=line>43</div><div class=line>44</div><div class=line>45</div><div class=line>46</div><div class=line>47</div><div class=line>48</div><div class=line>49</div><div class=line>50</div><div class=line>51</div><div class=line>52</div><div class=line>53</div><div class=line>54</div><div class=line>55</div><div class=line>56</div><div class=line>57</div><div class=line>58</div><div class=line>59</div><div class=line>60</div><div class=line>61</div><div class=line>62</div><div class=line>63</div><div class=line>64</div><div class=line>65</div><div class=line>66</div></pre></td><td class=code><pre><div class=line><span class=comment>--------------------------------------------------------------------------------</span></div><div class=line><span class=comment>-- 实验五 </span></div><div class=line><span class=comment>--2.1</span></div><div class=line><span class=operator><span class=keyword>CREATE</span> <span class=keyword>VIEW</span> S00311 <span class=keyword>AS</span> <span class=keyword>SELECT</span> * <span class=keyword>FROM</span> Student <span class=keyword>WHERE</span> Clno = <span class=string>'00311'</span> <span class=keyword>WITH</span> <span class=keyword>CHECK</span> <span class=keyword>OPTION</span></span></div><div class=line><span class=comment>-- 命令已成功完成。</span></div><div class=line></div><div class=line><span class=comment>--2.2</span></div><div class=line><span class=keyword>CREATE</span> <span class=keyword>VIEW</span> Grades(Sno, Sname, Cname, Grade, Clno) <span class=keyword>AS</span> <span class=keyword>SELECT</span> s.Sno, s.Sname, c.Cname, Cj.Grade, s.Clno <span class=keyword>FROM</span> Student s <span class=keyword>LEFT</span> <span class=keyword>JOIN</span> Cj <span class=keyword>ON</span> (Cj.Sno = s.Sno) <span class=keyword>LEFT</span> <span class=keyword>JOIN</span> Course c <span class=keyword>On</span> (Cj.Cno = c.Cno)</div><div class=line><span class=comment>-- 命令已成功完成。</span></div><div class=line></div><div class=line><span class=comment>--2.3</span></div><div class=line><span class=keyword>CREATE</span> <span class=keyword>VIEW</span> C_Student <span class=keyword>AS</span> <span class=keyword>SELECT</span> * <span class=keyword>FROM</span> Student <span class=keyword>WHERE</span> Clno = <span class=string>'00311'</span> <span class=keyword>AND</span> Sno <span class=keyword>IN</span> (<span class=keyword>SELECT</span> Sno <span class=keyword>FROM</span> Cj <span class=keyword>WHERE</span> Cno = <span class=string>'2'</span>)</div><div class=line><span class=comment>-- 命令已成功完成。</span></div><div class=line></div><div class=line><span class=comment>--3.1</span></div><div class=line><span class=keyword>SELECT</span> * <span class=keyword>FROM</span> S00311 <span class=keyword>WHERE</span> Ssex = <span class=string>'男'</span>;</div><div class=line><span class=comment>--（所影响的行数为 1 行）</span></div><div class=line><span class=comment>--2000101, 李勇, 男, 20, 00311</span></div><div class=line></div><div class=line><span class=comment>--3.2</span></div><div class=line><span class=operator><span class=keyword>INSERT</span> <span class=keyword>INTO</span> S00311(Sno, Sname, Ssex, Clno) <span class=keyword>VALUES</span> (<span class=string>'2001105'</span>, <span class=string>'刘辉'</span>, <span class=string>'男'</span>, <span class=string>'00311'</span>);</span></div><div class=line><span class=comment>--（所影响的行数为 1 行）</span></div><div class=line></div><div class=line><span class=comment>--3.3</span></div><div class=line><span class=operator><span class=keyword>UPDATE</span> S00311 <span class=keyword>SET</span> Sname = <span class=string>'刘辉'</span> <span class=keyword>WHERE</span> Sno = <span class=string>'2001105'</span>;</span></div><div class=line><span class=comment>--（所影响的行数为 1 行）</span></div><div class=line></div><div class=line><span class=comment>--3.4</span></div><div class=line><span class=operator><span class=keyword>DELETE</span> <span class=keyword>FROM</span> S00311 <span class=keyword>WHERE</span> Sno = <span class=string>'2001105'</span>;</span></div><div class=line><span class=comment>--（所影响的行数为 1 行）</span></div><div class=line></div><div class=line><span class=comment>--------------------------------------------------------------------------------</span></div><div class=line><span class=comment>-- 实验七 </span></div><div class=line><span class=comment>--2</span></div><div class=line><span class=comment>-- 创建登录 user3, 密码 passwd, 默认数据库 Student</span></div><div class=line>sp_addlogin user3, passwd, Student</div><div class=line>go</div><div class=line><span class=comment>-- 使用 Student 数据库添加用户 user3</span></div><div class=line><span class=operator><span class=keyword>USE</span> Student</span></div><div class=line><span class=keyword>go</span></div><div class=line>sp_adduser user3</div><div class=line><span class=keyword>go</span></div><div class=line><span class=comment>-- 已创建新登录。</span></div><div class=line><span class=comment>-- 已向 'user3' 授予数据库访问权。</span></div><div class=line></div><div class=line><span class=comment>--3.a</span></div><div class=line><span class=keyword>GRANT</span> <span class=keyword>SELECT</span> <span class=keyword>ON</span> Student <span class=keyword>TO</span> <span class=keyword>PUBLIC</span>;</div><div class=line><span class=comment>-- 命令已成功完成。</span></div><div class=line></div><div class=line><span class=comment>--3.b</span></div><div class=line><span class=operator><span class=keyword>GRANT</span> <span class=keyword>CREATE</span> <span class=keyword>TABLE</span>, <span class=keyword>CREATE</span> <span class=keyword>VIEW</span> <span class=keyword>TO</span> user1, user2;</span></div><div class=line><span class=comment>-- 命令已成功完成。</span></div><div class=line><span class=operator><span class=keyword>CREATE</span> <span class=keyword>TABLE</span> student1 (test <span class=built_in>int</span>);</span></div><div class=line><span class=comment>-- 命令已成功完成。</span></div><div class=line></div><div class=line><span class=comment>--3.c</span></div><div class=line><span class=operator><span class=keyword>GRANT</span> <span class=keyword>CREATE</span> <span class=keyword>TABLE</span> <span class=keyword>TO</span> user3;</span></div><div class=line><span class=comment>-- 授权者无 GRANT 权限。</span></div><div class=line></div><div class=line><span class=comment>--4</span></div><div class=line>REVOKE <span class=operator><span class=keyword>SELECT</span> <span class=keyword>ON</span> Student <span class=keyword>FROM</span> <span class=keyword>PUBLIC</span>;</span></div><div class=line><span class=comment>-- 命令已成功完成。</span></div><div class=line></div><div class=line><span class=comment>--5</span></div><div class=line>REVOKE <span class=operator><span class=keyword>CREATE</span> <span class=keyword>TABLE</span> <span class=keyword>FROM</span> user2;</span></div><div class=line><span class=comment>-- 命令已成功完成。</span></div></pre></td></tr></table></figure>
<div class=ujian-hook></div>
</div>
<footer class=article-footer>
<div class=bdsharebuttonbox>
<a href=# class=bds_tsina data-cmd=tsina title=分享到新浪微博></a>
<a href=# class=bds_qzone data-cmd=qzone title=分享到QQ空间></a>
<a href=# class=bds_tqq data-cmd=tqq title=分享到腾讯微博></a>
<a href=# class=bds_weixin data-cmd=weixin title=分享到微信></a>
<a href=# class=bds_tieba data-cmd=tieba title=分享到百度贴吧></a>
<a href=# class=bds_renren data-cmd=renren title=分享到人人网></a>
<a href=# class=bds_tqf data-cmd=tqf title=分享到腾讯朋友></a>
<a href=# class=bds_douban data-cmd=douban title=分享到豆瓣网></a>
<a href=# class=bds_tsohu data-cmd=tsohu title=分享到搜狐微博></a>
<a href=# class=bds_t163 data-cmd=t163 title=分享到网易微博></a>
<a href=# class=bds_taobao data-cmd=taobao title=分享到我的淘宝></a>
<a href=# class=bds_fx data-cmd=fx title=分享到飞信></a>
<a href=# class=bds_hi data-cmd=hi title=分享到百度空间></a>
<a href=# class=bds_more data-cmd=more></a>
</div>
<ul class=article-tag-list><li class=article-tag-list-item><a class=article-tag-list-link href=../tag/sql>SQL</a></li><li class=article-tag-list-item><a class=article-tag-list-link href=../tag/实验>实验</a></li><li class=article-tag-list-item><a class=article-tag-list-link href=../tag/数据库>数据库</a></li><li class=article-tag-list-item><a class=article-tag-list-link href=../tag/计算机>计算机</a></li></ul>
</footer>
</div>
<nav id=article-nav>
<a href="/fedora-16-configure/" id=article-nav-newer class=article-nav-link-wrap>
<strong class=article-nav-caption>Newer</strong>
<div class=article-nav-title>
Fedora 16 Verne 安装及配置使用
</div>
</a>
<a href="/computer-network-experiment-routing-ospf-algorithm/" id=article-nav-older class=article-nav-link-wrap>
<strong class=article-nav-caption>Older</strong>
<div class=article-nav-title>计算机网络 路由选择算法实验 OSPF算法 的修改代码</div>
</a>
</nav>
</article>
<section id=comments>
<div class=ds-thread data-thread-key="database-experiment-5-7/" data-title="数据库实验五 实验七 SQL命令" data-url="http://cweili.gitcafe.com/database-experiment-5-7/"></div>
</section>
</section>
<aside id=sidebar class=col-sm-3>
<div class="widget-wrap hidden-xs">
<h3 class=widget-title>分类</h3>
<div class=widget>
<ul class=category-list><li class=category-list-item><a class=category-list-link href=../category/学习笔记>学习笔记</a><span class=category-list-count>40</span></li><li class=category-list-item><a class=category-list-link href=../category/小生活>小生活</a><span class=category-list-count>27</span></li><li class=category-list-item><a class=category-list-link href=../category/杂物>杂物</a><span class=category-list-count>9</span></li></ul>
</div>
</div>
<div class=widget-wrap>
<h3 class=widget-title>最新评论</h3>
<div class=widget>
<div class=ds-recent-comments data-num-items=10 data-show-avatars=1 data-show-time=1 data-show-title=0 data-show-admin=1 data-excerpt-length=20>
<div class=text-center><i class="fa fa-refresh fa-spin"></i></div>
</div>
</div>
</div>
<div class=widget-wrap>
<h3 class=widget-title>最新文章</h3>
<div class=widget>
<ul>
<li>
<a href="/xixishidi/">河塘飞鸟西溪湿地</a>
</li>
<li>
<a href="/xizihu/">水光潋滟西子湖畔</a>
</li>
<li>
<a href="/xitang/">柳絮纷飞烟雨西塘</a>
</li>
<li>
<a href="/wuzhen/">灯火阑珊水映乌镇</a>
</li>
<li>
<a href="/stu3-zoo/">Stu3 Zoo</a>
</li>
<li>
<a href="/jshint-options/">JSHint配置参数详解</a>
</li>
<li>
<a href="/css3-jquery-rocket-to-top/">CSS3动画与jQuery实现返回顶部小火箭</a>
</li>
<li>
<a href="/rebuild-blog-gitcafe/">再一次重建我的博客</a>
</li>
<li>
<a href="/java-poi-excel/">Java使用POI创建Excel图表</a>
</li>
<li>
<a href="/hibernate-connect-sqlite-paging-bug-repair/">Hibernate 连接 SQLite (hibernate-sqlite) 分页bug的修复</a>
</li>
<li>
<a href="/web-page-color-chart/">更全的网页颜色表</a>
</li>
<li>
<a href="/quarrying-rocky-4/">20120407春游采石矶(四)</a>
</li>
<li>
<a href="/quarrying-rocky-3/">20120407春游采石矶(三)</a>
</li>
<li>
<a href="/quarrying-rocky-2/">20120407春游采石矶(二)</a>
</li>
<li>
<a href="/quarrying-rocky/">20120407春游采石矶(一)</a>
</li>
<li>
<a href="/ahpu-spring/">安徽工程大学的春天</a>
</li>
<li>
<a href="/helps-students-assembled-computer/">帮同学组装帅气小机箱电脑一台</a>
</li>
<li>
<a href="/nanjing-trip-4/">20120310南京二日行(四)</a>
</li>
<li>
<a href="/nanjing-trip-3/">20120310南京二日行(三)</a>
</li>
<li>
<a href="/nanjing-trip-2/">20120310南京二日行(二)</a>
</li>
</ul>
</div>
</div>
<div class="widget-wrap hidden-xs">
<h3 class=widget-title>手机阅读</h3>
<div class=widget>
<div class=qrcode style="background-image:url(http://qr.liantu.com/api.php?bg=eeeeee&fg=000000&el=l&w=192&m=0&text=http://cweili.gitcafe.com/database-experiment-5-7/)"></div>
</div>
</div>
<div class="widget-wrap hidden-xs">
<h3 class=widget-title>标签云</h3>
<div class="widget tagcloud">
<a href=../tag/acm style=font-size:10px>ACM</a><a href=../tag/c++ style=font-size:15.71px>C++</a><a href=../tag/css style=font-size:10px>CSS</a><a href=../tag/fedora style=font-size:15.71px>Fedora</a><a href=../tag/gnome style=font-size:11.43px>Gnome</a><a href=../tag/hibernate style=font-size:10px>Hibernate</a><a href=../tag/jshint style=font-size:10px>JSHint</a><a href=../tag/java style=font-size:11.43px>Java</a><a href=../tag/javascript style=font-size:12.86px>JavaScript</a><a href=../tag/linux style=font-size:17.14px>Linux</a><a href=../tag/pdo style=font-size:10px>PDO</a><a href=../tag/php style=font-size:12.86px>PHP</a><a href=../tag/poi style=font-size:10px>POI</a><a href=../tag/photoshop style=font-size:14.29px>Photoshop</a><a href=../tag/sae style=font-size:10px>SAE</a><a href=../tag/sql style=font-size:14.29px>SQL</a><a href=../tag/sqlite style=font-size:11.43px>SQLite</a><a href=../tag/stl style=font-size:11.43px>STL</a><a href=../tag/stu3 style=font-size:10px>Stu3</a><a href=../tag/twitter style=font-size:10px>Twitter</a><a href=../tag/virtualbox style=font-size:10px>VirtualBox</a><a href=../tag/jquery style=font-size:10px>jQuery</a><a href=../tag/三国杀 style=font-size:15.71px>三国杀</a><a href=../tag/乌镇 style=font-size:10px>乌镇</a><a href=../tag/互联网 style=font-size:10px>互联网</a><a href=../tag/动漫 style=font-size:11.43px>动漫</a><a href=../tag/动画 style=font-size:10px>动画</a><a href=../tag/南京 style=font-size:14.29px>南京</a><a href=../tag/博客 style=font-size:14.29px>博客</a><a href=../tag/实验 style=font-size:15.71px>实验</a><a href=../tag/容器 style=font-size:11.43px>容器</a><a href=../tag/小说 style=font-size:10px>小说</a><a href=../tag/微博 style=font-size:11.43px>微博</a><a href=../tag/心情 style=font-size:14.29px>心情</a><a href=../tag/摄影 style=font-size:17.14px>摄影</a><a href=../tag/操作系统 style=font-size:14.29px>操作系统</a><a href=../tag/数据库 style=font-size:18.57px>数据库</a><a href=../tag/旅行 style=font-size:20px>旅行</a><a href=../tag/日记 style=font-size:17.14px>日记</a><a href=../tag/杭州 style=font-size:11.43px>杭州</a>
</div>
</div>
<div class="widget-wrap hidden-xs">
<h3 class=widget-title>归档</h3>
<div class=widget>
<ul class=archive-list><li class=archive-list-item><a class=archive-list-link href=../archive/2014/09>September 2014</a><span class=archive-list-count>4</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2014/08>August 2014</a><span class=archive-list-count>4</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2012/09>September 2012</a><span class=archive-list-count>1</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2012/05>May 2012</a><span class=archive-list-count>2</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2012/04>April 2012</a><span class=archive-list-count>5</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2012/03>March 2012</a><span class=archive-list-count>5</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2011/12>December 2011</a><span class=archive-list-count>4</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2011/11>November 2011</a><span class=archive-list-count>18</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2011/10>October 2011</a><span class=archive-list-count>32</span></li><li class=archive-list-item><a class=archive-list-link href=../archive/2011/05>May 2011</a><span class=archive-list-count>2</span></li></ul>
</div>
</div>
<div class="widget-wrap hidden-xs">
<h3 class=widget-title>友情链接</h3>
<div class=widget>
<ul>
<li>
<a href=http://cweili.gitcafe.com target=_blank>主页</a>
</li>
</ul>
</div>
</div>
</aside>
</div>
<footer id=footer>
<div class=footer-wrap>
<div class=outer>
<div class=inner>
<div id=social-network>
<a class=link href=https://github.com/Cweili target=_blank><i class="fa fa-fw fa-github"></i></a>
<a class=link href=http://weibo.com/cweili target=_blank><i class="fa fa-fw fa-weibo"></i></a>
</div>
<div id=footer-info>
&copy; 2014 <a href=http://cweili.gitcafe.com target=_blank>Cweili</a><br>
Powered by <a href="http://hexo.io/" target=_blank>Hexo</a>.
Theme by <a href=http://cweili.gitcafe.com target=_blank>Cweili</a>.
</div>
</div>
</div>
</div>
</footer>
</div>
</div>
<div id=rocket-to-top>
<div class=onhover></div>
<div class=anim></div>
</div>
<link rel=stylesheet href=//libs.baidu.com/fontawesome/4.0.3/css/font-awesome.min.css css type=text/css>
<script src=//libs.baidu.com/jquery/1.11.1/jquery.min.js type=text/javascript></script><link rel=stylesheet href=//cdn.staticfile.org/fancybox/2.1.5/jquery.fancybox.min.css type=text/css>
<script src=//cdn.staticfile.org/fancybox/2.1.5/jquery.fancybox.min.js type=text/javascript></script><script src=../js/script.js type=text/javascript></script><script type=text/javascript>var duoshuoQuery={short_name:"cweiligitcafe"};</script><script src=//static.duoshuo.com/embed.js type=text/javascript></script><script type=text/javascript>var ujian_config={num:10,showType:3};</script><script src="http://v1.ujian.cc/code/ujian.js?uid=1539214&_=.js" type=text/javascript></script><script type=text/javascript>window._bd_share_config={common:{bdSnsKey:{},bdPopTitle:"分享到",bdMini:2,bdPopupOffsetLeft:28,bdPopupOffsetTop:108,bdMiniList:["sqq","mshare","bdysc","kaixin001","ibaidu","baidu","ff","qy","meilishuo","mogujie","diandian","ty","youdao","sdo"],bdPic:"",bdStyle:1,bdSize:"24"},share:{},image:{viewList:["tsina","qzone","tqq","weixin","tieba","renren","tqf","douban","tsohu","t163","taobao","fx","hi"],viewText:" ",viewSize:"24"},selectShare:{bdContainerClass:"article",bdSelectMiniList:["tsina","qzone","tqq","weixin","tieba","renren","tqf","douban","tsohu","t163","taobao","fx","hi"]}},document.write('<script type="text/javascript" src="http://bdimg.share.baidu.com/static/api/js/share.js?cdnversion='+~(-new Date/36e5)+'"><\/script>');</script><div id=stat-wrap>
<script src="http://s19.cnzz.com/stat.php?id=1252976445&web_id=1252976445" type=text/javascript></script></div></body></html>